package com.zzgele.qmzb.api.dao;

import com.zzgele.qmzb.api.core.Mapper;
import com.zzgele.qmzb.api.model.BonusPackage;
import org.springframework.stereotype.Repository;

@Repository
public interface BonusPackageMapper extends Mapper<BonusPackage> {
//    @Select("select * from tb_bonus_package where id=#{id}")
//    @Results(value = {
//            @Result(property = "userId", column = "user_id"),
//            @Result(property = "phone", column = "phone"),
//            @Result(property = "bonusAmount", column = "bonus_amount"),
//            @Result(property = "price", column = "price"),
//            @Result(property = "maxPrice", column = "max_price"),
//            @Result(property = "type", column = "type"),
//            @Result(property = "expireTime", column = "expire_time"),
//            @Result(property = "prePrice", column = "pre_price")
//    })
//    BonusPackage selectBonusPackageById(Long id);
//
//    @Insert("insert into tb_bonus_package (user_id,phone,bonus_amount,price,max_price,type" +
//            ",expire_time,pre_price) values(#{userId},#{phone}, #{bonusAmount},#{price},#{maxPrice}, #{type},#{expireTime},#{prePrice})")
//    @SelectKey(statement = "select @@IDENTITY as id", keyProperty = "id", before = false, resultType = Integer.class)
//    int insert(BonusPackage bonusPackage);
}